***********************************************
**RESTORING TRUST IN MEXICO’S POLICE***********
**Authors: Ana I. López García & Sarah Berens**
***********************************************

***Tables - SM
*Table A1:  Descriptive statistics – Respondents’ characteristics	
*Table A4: OLS Regression: Perceptions of police effectiveness	
*Table A5: OLS Regression: Perceptions of police misconduct	
*Table A6: Marginal Effects on Police Effectiveness of the Gender Treatment by Occupational Background Treatment	
*Table A7: Marginal Effects on Police Misconduct of the Gender Treatment by Occupational Background Treatment	
*Table A8: Perceptions of police effectiveness, alternative estimations	
*Table A9: Perceptions of police misconduct, alternative estimations	
*Table A10: OLS Regression: Perceptions of police effectiveness, additional controls	
*Table A11: OLS Regression: Perceptions of police misconduct, additional control
*Table A12: OLS Regression: Perceptions of police effectiveness and police misconduct, federal state-based fixed effect

use "Data ready E6.dta", clear 

********************************************************
*1. DATA DESCRIPTION
*1.1 Summary Statistics
set matsize 10000 

sum2docx E6_police_eff E6_police_mis female female age_groups1 age_groups2 age_groups3 age_groups4 age_groups5 edlevel1 edlevel2 edlevel3 edlevel4 ///
college_higher income_cat1 income_cat2 income_cat3 employed informal good_house_economy good_country_economy income_perceptions* migrant ///
remittances self_placement* incumbent indigenous religiosity crime_victim victim* crime_fear unsafe_neigh unsafe_country police_abuse crime_state vigilantes_neigh ///
police_bribe using "TableA1.docx", replace stats(N mean sd min median max) title("Table A1: Descriptive statistics – Respondents’ characteristics") 
 
****************************************************
*2. REGRESSION TABLES
****************************************************

*Table A4 - Police effectiveness - main effects 
reg E6_police_effectiveness i.E6_vign2 i.E6_vign1
outreg2 using "Table_A4.xls", replace ctitle(ols) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) symbol(***, **, *, +) ///
	addnote("Source: Mexico Pollfish Survey 2021/22") see label title ("Table A4: OLS regression: Perceptions of police effectiveness") 

reg E6_police_effectiveness i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant
outreg2 using "Table_A4.xls", append ctitle(ols + controls) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) symbol(***, **, *, +) ///
	addnote("Source: Mexico Pollfish Survey 2021/22") see label title ("Table A4: OLS regression: Perceptions of police effectiveness") 

***********************************************************
*Table A5 - Police misconduct - main effects 
reg E6_police_misconduct i.E6_vign2 i.E6_vign1
outreg2 using "Table_A5.xls", replace ctitle(ols) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) symbol(***, **, *, +) ///
	addnote("Source: Mexico Pollfish Survey 2021/22") see label title ("Table A5: OLS regression: Perceptions of police misconduct") 

reg E6_police_misconduct i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant
outreg2 using "Table_A5.xls", append ctitle(ols + controls) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) symbol(***, **, *, +) ///
	addnote("Source: Mexico Pollfish Survey 2021/22") see label title ("Table A5: OLS regression: Perceptions of police misconduct") 
	
		
**********************************************************
**Table A6: Marginal Effects on Police Effectiveness of the Gender Treatment by Occupational Background Treatment
reg E6_police_effectiveness i.E6_vign1##i.E6_vign2
margins E6_vign1@E6_vign2, contrast(pveffects nowald) post
outreg2 using "Table_A6.xls", replace ctitle(ols) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) symbol(***, **, *, +) ///
	addnote("Source: Mexico Pollfish Survey 2021/22") see label  
reg E6_police_effectiveness i.E6_vign1##i.E6_vign2 i.female i.age_range i.education_cat i.income_level i.employed i.migrant
margins E6_vign1@E6_vign2, contrast(pveffects nowald) post
outreg2 using "Table_A6.xls", append ctitle(ols + controls) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) symbol(***, **, *, +) ///
	addnote("Source: Mexico Pollfish Survey 2021/22") see label 

**********************************************************
*Table A7: Marginal Effects on Police Misconduct of the Gender Treatment by Occupational Background Treatment
reg E6_police_misconduct i.E6_vign1##i.E6_vign2
margins E6_vign1@E6_vign2, contrast(pveffects nowald) post
outreg2 using "Table_A7.xls", replace ctitle(ols) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) symbol(***, **, *, +) ///
	addnote("Source: Mexico Pollfish Survey 2021/22") see label 
	
reg E6_police_misconduct i.E6_vign1##i.E6_vign2 i.female i.age_range i.education_cat i.income_level i.employed i.migrant
margins E6_vign1@E6_vign2, contrast(pveffects nowald) post
outreg2 using "Table_A7.xls", append ctitle(ols + controls) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) symbol(***, **, *, +) ///
	addnote("Source: Mexico Pollfish Survey 2021/22") see label 

	
*******************************************************
*Table A8: Perceptions of police effectiveness, alternative estimations

reg E6_police_effectiveness i.E6_vign2 i.E6_vign1
outreg2 using "Table_A8.xls", replace ctitle(ols) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label 

ologit E6_police_effectiveness i.E6_vign2 i.E6_vign1
outreg2 using "Table_A8.xls", append ctitle(ologit) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label
	
oprobit E6_police_effectiveness i.E6_vign2 i.E6_vign1
outreg2 using "Table_A8.xls", append ctitle(oprobit) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label
	

****************************************************
*Table A9: Perceptions of police misconduct, alternative estimations

reg E6_police_misconduct i.E6_vign2 i.E6_vign1
outreg2 using "Table_A9.xls", replace ctitle(ols) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label 

ologit E6_police_misconduct i.E6_vign2 i.E6_vign1
outreg2 using "Table_A9.xls", append ctitle(ologit) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label
	
oprobit E6_police_misconduct i.E6_vign2 i.E6_vign1
outreg2 using "Table_A9.xls", append ctitle(oprobit) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label
	
	

**********************************************************
*Table A10: OLS Regression:  Perceptions of police effectiveness, additional controls
reg E6_police_effectiveness i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant 
outreg2 using "Table_A10.xls", replace ctitle(ols + controls) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label 

reg E6_police_effectiveness i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant ///
	i.crime_victim
outreg2 using "Table_A10.xls", append ctitle(ols + crime) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label 

reg E6_police_effectiveness i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant ///
	i.unsafe_neigh
outreg2 using "Table_A10.xls", append ctitle(ols + fear) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label ///
	
reg E6_police_effectiveness i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant ///
	i.unsafe_country
outreg2 using "Table_A10.xls", append ctitle(ols + fear country) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label
	
reg E6_police_effectiveness i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant ///
	i.police_abuse
outreg2 using "Table_A10.xls", append ctitle(ols + police abuse) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label 
	
reg E6_police_effectiveness i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant ///
	i.police_bribe
outreg2 using "Table_A10.xls", append ctitle(ols + police bribe) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label 
	
reg E6_police_effectiveness i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant ///
	i.vigilantes_neigh
outreg2 using "Table_A10.xls", append ctitle(ols + vigilantes) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label 
	

**********************************************************
*Table A11: OLS Regression:  Perceptions of police misconduct, additional controls
reg E6_police_misconduct i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant 
outreg2 using "Table_A11.xls", replace ctitle(ols + controls) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label 

reg E6_police_misconduct i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant ///
	i.crime_victim
outreg2 using "Table_A11.xls", append ctitle(ols + crime) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label 

reg E6_police_misconduct i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant ///
	i.unsafe_neigh
outreg2 using "Table_A11.xls", append ctitle(ols + fear) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label ///
	
reg E6_police_misconduct i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant ///
	i.unsafe_country
outreg2 using "Table_A11.xls", append ctitle(ols + fear country) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label
	
reg E6_police_misconduct i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant ///
	i.police_abuse
outreg2 using "Table_A11.xls", append ctitle(ols + police abuse) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label 
	
reg E6_police_misconduct i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant ///
	i.police_bribe
outreg2 using "Table_A11.xls", append ctitle(ols + police bribe) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label 
	
reg E6_police_misconduct i.E6_vign2 i.E6_vign1 i.female i.age_range i.education_cat i.income_level i.employed i.migrant ///
	i.vigilantes_neigh
outreg2 using "Table_A11.xls", append ctitle(ols + vigilantes) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) ///
	symbol(***, **, *, +) addnote("Source: Mexico Pollfish Survey 2021/22") see label


****************************************************
*Table A12: OLS Regression: Perceptions of police effectiveness and police misconduct, federal state-based fixed effects
******************************************************
reg E6_police_effec i.E6_vign2 i.E6_vign1 i.state
outreg2 using "Table_A12.xls", replace ctitle(ols) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) symbol(***, **, *, +) ///
	addnote("Source: Mexico Pollfish Survey 2021/22") see label 
	
reg E6_police_effec i.E6_vign2 i.E6_vign1 i.state i.female i.age_range i.education_cat i.income_level i.employed i.migrant 
outreg2 using "Table_A12.xls", append ctitle(ols) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) symbol(***, **, *, +) ///
	addnote("Source: Mexico Pollfish Survey 2021/22") see label

reg E6_police_misc i.E6_vign2 i.E6_vign1 i.state
outreg2 using "Table_A12.xls", append ctitle(ols) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) symbol(***, **, *, +) ///
	addnote("Source: Mexico Pollfish Survey 2021/22") see label

reg E6_police_misc i.E6_vign2 i.E6_vign1 i.state i.female i.age_range i.education_cat i.income_level i.employed i.migrant 
outreg2 using "Table_A12.xls", append ctitle(ols) excel dec(3) alpha(0.001, 0.01, 0.05, 0.1) symbol(***, **, *, +) ///
	addnote("Source: Mexico Pollfish Survey 2021/22") see label 

